SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd1925c5982b9fad6a4526e61e32298bc2f8982a1544d38ab18d81df681a6712d' 
  AND token = '2mUPeaqB2Lf408JrfF2A4yCLHU/XqAiE9juVhEkpPTw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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