SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '734db781f5b3e7f38c1cb653ce3b4eaae05a1ba74c7c8760e48ba77ae922004a' 
  AND token = 'fubjt4s+ysNekz6eOhTup0rUKaQo7OfQ+nvySPSBAtc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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