SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c01065c12519f0422a77b96b17ef3efe14401a0ea3a4b39177dbf4235acbaa71' 
  AND token = 'xvu5bDYiMrGjVVOg3skwlipp0hZu2W+L8uBddnwkwt4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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