UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E3C4kDKfPDlRuvwuGrc9JZxSyGSXtfQLmfpJUuOzSyU='
WHERE
key_id = '900c529e47638ed8b0642fd4dd1c0004213dae40565d5b2624f7fc6b75f84ffc'
AND (
token = 'E3C4kDKfPDlRuvwuGrc9JZxSyGSXtfQLmfpJUuOzSyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)