UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnuhrlp8dNoG8YNqVhrltalTLKJSWgEX7xa2+r8lJzI='
WHERE
key_id = 'c114e34369a2b4a9a730dd1387159090c50e3d6118b305c10d79ec1fc7a1f9c8'
AND (
token = 'fnuhrlp8dNoG8YNqVhrltalTLKJSWgEX7xa2+r8lJzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)