SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'fde74705c586f9f858be93647744d45ad52bd0c93d5db27eb1b295df411f1a9f' 
  AND token = 'ZMl/oNw811F61BB30OgWf3RH4HlA/3wiw/FVYEktp74=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

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