UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y+q8UIzjNcFi68eucWBWpyAmjiYNRDMBCW6CHym4OsI='
WHERE
key_id = 'c475d095c0270016a39b9953ffc3b971710825623b4f93af55ebe0f52bdd6b85'
AND (
token = 'Y+q8UIzjNcFi68eucWBWpyAmjiYNRDMBCW6CHym4OsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)