UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NLyZ3H0ORANKuUJ8DZoQe+oYDFAViJd46dI+9Qxni5U='
WHERE
key_id = '87ca3936610c428a20c1144a83e6e843dfc797ee8e2927a3a2b9a58c10c35be2'
AND (
token = 'NLyZ3H0ORANKuUJ8DZoQe+oYDFAViJd46dI+9Qxni5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)