SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7849ba5c7ec2915e881100afa8160e41b9a2ac153f6219eb8aaf0ee8463c4817' 
  AND token = 'GyVbm9pGVUHEXSU9vNUmTGfzeeWl2p8OMNyWE3q/3Tg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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