UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ox0ER3nLSXMCS0Abkh4l8Hx53YUX9RtQutH7ngOxQ4U='
WHERE
key_id = 'b36d9225845fc7ff8e5d52da6af78c9d31b16f87bb603693785146388733b247'
AND (
token = 'Ox0ER3nLSXMCS0Abkh4l8Hx53YUX9RtQutH7ngOxQ4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)