UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sr4oQ4TGF/CVN/X1VT7c78Wf+cwm1UwOAW1HcvLSlS8='
WHERE
key_id = '42b6d0d4ac8ce6d7024e01e05eb80b42efa08bc9fac488d9a56091dfcace82ac'
AND (
token = 'sr4oQ4TGF/CVN/X1VT7c78Wf+cwm1UwOAW1HcvLSlS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)