UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1ocIqNU3TgHJGHZC7QBXepi71Z2a/UAykctuj/w3/w='
WHERE
key_id = '086d77120e3a02a4453a3709630423df9e88174e049d6c1608ca91ad4e6e0e38'
AND (
token = 'N1ocIqNU3TgHJGHZC7QBXepi71Z2a/UAykctuj/w3/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)