UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0v7mtxB6Lq+1CHlDefro90fGaiw+TK3LzOzAkN2wSsA='
WHERE
key_id = '4ca7392493f9f651403b9157445598bb9a5ffa2040dbd4f78daf025e7f27d61a'
AND (
token = '0v7mtxB6Lq+1CHlDefro90fGaiw+TK3LzOzAkN2wSsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)