UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lpFpyT8DKNVdmezXIjSDKOPP7IBXS0sjFKvX1sg3bdU='
WHERE
key_id = '13c11afcc18fe5b8022b5900b1f91ef2321a230fe18a7041dae3f7cd157d5d3c'
AND (
token = 'lpFpyT8DKNVdmezXIjSDKOPP7IBXS0sjFKvX1sg3bdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)