SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '08b2523bc04a6daf3d037e52aa60fa8d570e9390a217c5d9fd5d87c593931b1c' 
  AND token = 'MYdNXSThZn3bq7rV1ok67k0oW5yOJhDhzFf7tz0ybc4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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