SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a9b4ed79b0abccb2d5a429908f3db09c88162ee4aa91e6a2b309986f3d4a7215' 
  AND token = 'u2Vj4MI614XB9qpzQ2h8fqp8+p1g2Ugwiw7i8JsFXUQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00051

JSON explain

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