UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bKEZcvFatlKuZynsfEkptt01drE+HXSw3L12D9ZzQ4U='
WHERE
key_id = '6d1ea80148c538b29c4d9bc1081d49ed18baa394248cd75ef068e27b0352eb6d'
AND (
token = 'bKEZcvFatlKuZynsfEkptt01drE+HXSw3L12D9ZzQ4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)