UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TtLdC+KOoU6I3QvplMtnGUogWnpeo/u13/wHrRti/m0='
WHERE
key_id = '78b2aec3410ba5140048f2d909b5d60984a99a13bd930fd1ebecf70b6cca0d29'
AND (
token = 'TtLdC+KOoU6I3QvplMtnGUogWnpeo/u13/wHrRti/m0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)