UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHuPyuzO37tXlhC7EnzyOM94G//hBnkTJg7sdYgiWeY='
WHERE
key_id = '021ae453c9d5ba9c26bb3e3e79c913ef9f65fc1ff08b30cd4790918b3bfbe44f'
AND (
token = 'tHuPyuzO37tXlhC7EnzyOM94G//hBnkTJg7sdYgiWeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)