UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OYL/zWBnC8wQlYVMvSMFdAtDsV7p60YIIFDJSMnLg4='
WHERE
key_id = '00b5c128bb2bd715db9ccde6548b513c0fd0dee44614bb6b9ea9d48e32aff2d7'
AND (
token = '1OYL/zWBnC8wQlYVMvSMFdAtDsV7p60YIIFDJSMnLg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)