UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LJRecFjEhEJunppNY1uGUNaXDjbCC+zzAisrJoaqxqI='
WHERE
key_id = 'de9f402291708d1b772aeda42df0afb8df0a4a6cfdcd87cb0e38e923be040957'
AND (
token = 'LJRecFjEhEJunppNY1uGUNaXDjbCC+zzAisrJoaqxqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)