UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rSo/3jHHcMSoANq1X1af/e16FRTez/6RWdoRNwrWe4w='
WHERE
key_id = '8aaceefd26b8824ed6c1f63bc6cb31071d414a82c3567cef7beef71b5c9c5c20'
AND (
token = 'rSo/3jHHcMSoANq1X1af/e16FRTez/6RWdoRNwrWe4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)