UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vWYE2NvbqoxR5lf0hse+qXoADl5laL2ek9YibNdOnaE='
WHERE
key_id = 'a350e712e501477b1be9c53608a8599c3d3cf95310bb9c8fff9a88587e337556'
AND (
token = 'vWYE2NvbqoxR5lf0hse+qXoADl5laL2ek9YibNdOnaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)