SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e838b1dc804ae7bae2aef9567f0a3e38d06b203669b631e3bc2348d6ab79ed73' 
  AND token = 'Hn8PmOzaS+N4mTK4B5gjSTYXhoOpzK7RQHKtXD8Ans0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}