SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2e3a9056731e59a7494ac5d8b8bc0b27b81c084b40652f79918c2ea238929222' 
  AND token = 'f8T1WKbrZ0v+R3Xd1O8Jmw1Ah/SRdSt+h2Z1Nzo9AEQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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