SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'dfab99a3e750c7746e8a0023c9282c43d3e3b9730111113d73946577d3b36872' 
  AND token = 'ksAT4utXPTf95q4P/dFSXxv8/Be3wUBFAyyj+Yv879c=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00066

JSON explain

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