UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RxM+pkJDSu7SH9EF/odabn1dj1tJ/EFKRuaT03bLmtE='
WHERE
key_id = 'da446ac9eb7edeb5d968254862046d03c0a826bbf092fa3c4cef8e883d6c1efe'
AND (
token = 'RxM+pkJDSu7SH9EF/odabn1dj1tJ/EFKRuaT03bLmtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)