UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OjIdNn4IYtIRRkYTiI3sAQvMHXYJEFlYiJtuqoiR7jQ='
WHERE
key_id = '0d790347512114742ff7ba9a48868210b17c1c9e4f48cb48892ea346857c4bf4'
AND (
token = 'OjIdNn4IYtIRRkYTiI3sAQvMHXYJEFlYiJtuqoiR7jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)