SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9fb36a6b833b605d8b3d7b0438d8a3a1e64a3e64fda716e2348428c7a0dfdd48' 
  AND token = 'vfhOa84yf6d7nhcnT+vUiWf8Ky9lxmxuIiHw0i9oWR0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

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