UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6c1moDpTpbavTJur12/pTTpQPZjd7ktUf/Hbz8gxK4g='
WHERE
key_id = '141ac984def28b4f6378cc1238a97e2a938d74f84ad75644b6bd06da16b55382'
AND (
token = '6c1moDpTpbavTJur12/pTTpQPZjd7ktUf/Hbz8gxK4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)