SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c90f1e2603a9b772925b2d09a1d9ed4cdf15d222f85d32c7e9143f3bf2d2c7e5' 
  AND token = 'JE7Zzn5iOoRHhRz4BhhTQgTl1fEIr3KNj/Qrr0Pv85M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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