UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '102IWrGcy6NMzJ1g+1ZVqgL1Srx4bxYTCye6NTv03IU='
WHERE
key_id = '34ab79a9bf423554089ae5c0ef54234282e951a90abcef4c02220fcdba7aa86f'
AND (
token = '102IWrGcy6NMzJ1g+1ZVqgL1Srx4bxYTCye6NTv03IU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)