UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eRox4uYLhLHgxOsWZAZRN8y++/QTOzWnOI7vTpVF79E='
WHERE
key_id = 'cad9099337e7d35b619a20e5a9b201d90c6026ac2eb6a22abaf528e10b322eb9'
AND (
token = 'eRox4uYLhLHgxOsWZAZRN8y++/QTOzWnOI7vTpVF79E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)