SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'caef63b53743f63a4b51555add9121597f6b88a3fde83f363b0f4be348a4546c' 
  AND token = 'f9xDreg4iQAYnG6gBQMBOCkYh9uf146f5ZWA+H6ydP0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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