UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/O2WhOXEiXVzSRo6thpQil+wF0LoIhcN+cXuJjJulo='
WHERE
key_id = '4f4fe9f83ad1e3aa48df68bf7dbcce64cf06fd0b3e0dd4418000f27581067fd3'
AND (
token = 'v/O2WhOXEiXVzSRo6thpQil+wF0LoIhcN+cXuJjJulo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)