SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '53b5e8dbc1e1172d784cb95e4592ec8db6d25c02688125f034d40f1e531ad547' 
  AND token = '6on8HFa1nOKqzF4w+Ay5R4WfCFYVo0OYnAS6zD920wk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00052

JSON explain

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