SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '66c5c3599b35b66b836a14e4f78bd73d5642f46d089a8c7325363c6afa166626' 
  AND token = 'jeQ/p0D4W3mHFthyruPbiRBAn9A74h9p7rhKNoXq338=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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