SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e477c6044e98e650d1a54da93eb7c3288cd2024e727034d8cdb8e2e7c1ae11af' 
  AND token = 'vA9F+6z1mBQA/WUYjPUH2ZCZjIfu7hSvm9S6GemhmjM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00040

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}