UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I+K7sBB65WlgPY0L3PcQK+ZYpQ4slWbS1Ti+e1XpOSw='
WHERE
key_id = 'ce38c5738eb98b5bb440bc97263b4abe339992ee3f111778bcdfceaac81f2533'
AND (
token = 'I+K7sBB65WlgPY0L3PcQK+ZYpQ4slWbS1Ti+e1XpOSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)