UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1CcNoHAYU/vIsvLjCW+BXLFrjoKxVGvBDuKhYMvWn90='
WHERE
key_id = '7e11ba9c7f3c03f2790cd52324ba37aee59af3625db03566d8c610cd9f5c87c9'
AND (
token = '1CcNoHAYU/vIsvLjCW+BXLFrjoKxVGvBDuKhYMvWn90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)