SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1e1bbf9980020c8614bb0fe939928863ea44028f5ef026492f1bb27bf043c9f8' 
  AND token = 'x1udSnf2+AfaclvLA69aka2XJTPfaRqvws4k9X1Oekc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

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