SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8577c1800d8f3b3532880e8a0e0064ed5ade7e9c9b409fc9aa2dcaca6358fbcb' 
  AND token = 'tlk7uFZ0rOB1yb4VzzZ56eQVYeLz0mvB7awwrz1zKDo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00014

JSON explain

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