UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ztp5S3e0eY3TsqouUaL3tnT/0/ZY3AsX3L1upOZrgc='
WHERE
key_id = '90c40523f2232b378e02dea03039411c667b5e1609c45042b334bbbe9cecc549'
AND (
token = '+ztp5S3e0eY3TsqouUaL3tnT/0/ZY3AsX3L1upOZrgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)