UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PRhztkVOl2D4eg24n0kG6b/MvQcj9PCgLMUJKOIgeOY='
WHERE
key_id = 'b98e72a2beb517fff290c40d5a8f9b7726b4b9119f4f5f8d4dbbf1519fbe901b'
AND (
token = 'PRhztkVOl2D4eg24n0kG6b/MvQcj9PCgLMUJKOIgeOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)