SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4ec3c0fe41fd0a39075b2d9d9031b77d195253dcb8b6b0ac54fce43b7b3a09ce' 
  AND token = '0l6dnZyRYLFmS3v0kRRizk3UYugNt0oHLijzPqr2wW0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00050

JSON explain

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