UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0L8MrOYcPVSIaX5Ga3LQuVIXHBzGhw96fm1ARpO9QNQ='
WHERE
key_id = '9466b1e7758ad303a9c2793bee20182e7b35302812c8cc5b67eba51eeafbc441'
AND (
token = '0L8MrOYcPVSIaX5Ga3LQuVIXHBzGhw96fm1ARpO9QNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)