UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UA23QG2XAsdW2DqHHraJoC79EhQzBJi25ADkTZ7eFMU='
WHERE
key_id = 'e793a0f33c0179e342b85c6b5f825724a48f097d320ffe9d41742cbbbde3ddbe'
AND (
token = 'UA23QG2XAsdW2DqHHraJoC79EhQzBJi25ADkTZ7eFMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)