UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LjmPEl3jpBUdbl/jRT9d2DCHVwKQFE9kSN8wUOh1ugY='
WHERE
key_id = '8f36badecf45bfc01a0a48505e84b5dcc6d5b6bd63d84cb2e7b3ad2d8b01192e'
AND (
token = 'LjmPEl3jpBUdbl/jRT9d2DCHVwKQFE9kSN8wUOh1ugY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)