UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzNh91ZQO88IOuCZzxqGRwLzxWzwqbYyQboA8T66xYI='
WHERE
key_id = '8522ea343fabadf1c6f74a24313782e4d152e30dc53de029ad487bc0d961d8f8'
AND (
token = 'HzNh91ZQO88IOuCZzxqGRwLzxWzwqbYyQboA8T66xYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)