UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QV7SzrCvrqK9b4834jc1s0wD7MY5GUwlmjg7mlM6wr0='
WHERE
key_id = 'ec0161c4e0151999da28b7168f2718f6839dbfede31def16aa8254e6b17f0ff5'
AND (
token = 'QV7SzrCvrqK9b4834jc1s0wD7MY5GUwlmjg7mlM6wr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)