SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '453a11b165a6f795c4adddcd6e0889533e3f82e4413bfc127462d445c7c29998' 
  AND token = 'TC3VyVbJ9cguz6UQPXGdef7Ppd5YoFh7ig6CHTOmXn0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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