UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQa2CKOfomv0/SxD+rOIkIie6eyyFROkiIOvdbvxjW4='
WHERE
key_id = '0652df77edb0125dc8ec88a768ee385c0ea5d18655a569f73aed6c8a647b3bfe'
AND (
token = 'LQa2CKOfomv0/SxD+rOIkIie6eyyFROkiIOvdbvxjW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)