UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+W2vn1KHlcS5/jy4r5/dE+FnKNVSfpnrrFGffsspiaU='
WHERE
key_id = 'e3a20c601ae3371b0f2c6bcadd2a88327de847abe5969ab11d3180cdbebc0679'
AND (
token = '+W2vn1KHlcS5/jy4r5/dE+FnKNVSfpnrrFGffsspiaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)