UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vLXP78iz4LH6cQ3yuUWNIjdry0/NFlC5hZY54Y3dW54='
WHERE
key_id = '4c2fd328ac1090311e6b7f5d25243bd53f618193948fc1463d3b3d2e8dd6dd47'
AND (
token = 'vLXP78iz4LH6cQ3yuUWNIjdry0/NFlC5hZY54Y3dW54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)