UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eO0f/LNh8pj6mpqSIB+y4l3QeP7AApwD5rhDi0+P7B0='
WHERE
key_id = '8ebf0cc55ce4a9fab92711ede5f68178fad6a2a80eacdca922692b6bea326952'
AND (
token = 'eO0f/LNh8pj6mpqSIB+y4l3QeP7AApwD5rhDi0+P7B0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)