UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06+H1XsKO/kFL+DaK0SVqds2Oh3Fep+0ZmrvkMqsra4='
WHERE
key_id = '5778e95108d04779c5f198154fa8177275a25e2dee1367dc2067f04e693d94ca'
AND (
token = '06+H1XsKO/kFL+DaK0SVqds2Oh3Fep+0ZmrvkMqsra4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)