SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7529f7b3bc258964fb5c14aa77714bf0bfbc39060b119d68726fd007bf62e375' 
  AND token = 'F9UmmBpR0qd5WOF73xdjwuXduo+bTSagXV6eiIx4tVM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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