UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4OHAUaFpYENf8oNINGhTGJqXOBW0TABQ99cbma9mEk='
WHERE
key_id = '12ddc0bf90b1076881c8949cc4bdb3b718886977781edeb2743b5e2ad61a3fb9'
AND (
token = 'A4OHAUaFpYENf8oNINGhTGJqXOBW0TABQ99cbma9mEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)