SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1abbd2a34d23c3ed5b81d619fd5615f1f0b52bacc338f94dcaf9de164c6716d2' 
  AND token = 'VmKwtlgxwM1OH50hEc6YwBGBQ9uUQkNrLMz+kT9MFUA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00049

JSON explain

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