UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29Diau9r4Ye9heOhyDZcXKZWWDLTMcmLlutkChWqxRM='
WHERE
key_id = 'aa3542c7f91c2bebf4b2368166dd6abba9c0ea0110669eb3f5fce5a861560611'
AND (
token = '29Diau9r4Ye9heOhyDZcXKZWWDLTMcmLlutkChWqxRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)