UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrUaX8yHma6x3vLTHYNPX3gbp8YUUsS9HhRhkTJz/YE='
WHERE
key_id = '59f808e9e90db9c91fed6364a4afe9c34340dd49ca9f0f05ce4a6e165842fe66'
AND (
token = 'IrUaX8yHma6x3vLTHYNPX3gbp8YUUsS9HhRhkTJz/YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)