UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBkh/GQHmb/GpQV0qbh4+HnkjfmPxR6ax+zB5yGqcsI='
WHERE
key_id = '5be71a84316d50b75a8a6b8ba7d080c47c663353cf0079679cc1e6d1c76236c6'
AND (
token = 'XBkh/GQHmb/GpQV0qbh4+HnkjfmPxR6ax+zB5yGqcsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)